package com.be.beadmin.design.entity;

import com.be.beadmin.common.entity.BaseEntity;
import lombok.Data;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;

/**
 * @Author: Mengyang Zhu
 * @Date: 2023/2/16 20:27
 * @Description: 柜体的BOM信息
 */
@Table(name="T_OM_ProductBomOverview")
@Data
@Entity
public class ProductBomOverview extends BaseEntity {
    @Column(name = "productCode",columnDefinition = "VARCHAR(50) not null COMMENT '产品/柜体编号' ")
    private String productCode;
    @Column(name = "bomCode",columnDefinition = "VARCHAR(50) COMMENT 'BOM编号' ")
    private String bomCode;
    @Column(name = "bomSequence",columnDefinition = "VARCHAR(50) COMMENT 'BOM行号' ")
    private String bomSequence;
    @Column(name = "materialCode",columnDefinition = "VARCHAR(50) COMMENT '物料编码' ")
    private String materialCode;
    @Column(name = "materialName",columnDefinition = "VARCHAR(50) COMMENT '物料名称' ")
    private String materialName;
    @Column(name = "materialClassification",columnDefinition = "VARCHAR(50) COMMENT '物料分类' ")
    private String materialClassification;
    @Column(name = "materialType",columnDefinition = "VARCHAR(50) COMMENT '物料种类' ")
    private String materialType;
    @Column(name = "materialSpec",columnDefinition = "VARCHAR(50) COMMENT '规格' ")
    private String materialSpec;
    @Column(name = "materialQty",columnDefinition = "double COMMENT '所需物料数量' ")
    private double materialQty;
    @Column(name = "partCode",columnDefinition = "VARCHAR(50) COMMENT '产品编码:订货号？' ")
    private String partCode;
    @Column(name = "changeStatus",columnDefinition = "int COMMENT default 0 '变更状态：释放前有没有变更过，1- 是/0 -否' ")
    private int changeStatus;
    @Column(name = "positionNo",columnDefinition = "VARCHAR(50) COMMENT '(安装)位置号' ")
    private String positionNo;
    @Column(name = "unit",columnDefinition = "VARCHAR(50) COMMENT '单位' ")
    private String unit;
    @Column(name = "brand",columnDefinition = "VARCHAR(50) COMMENT '品牌' ")
    private String brand;
    @Column(name = "archiveFlag",columnDefinition = "int COMMENT '归档标识,0:未归档,1:已归档' ")
    private int archiveFlag;
    @Column(name = "tenantId",columnDefinition = "VARCHAR(50) COMMENT '租户id' ")
    private String tenantId;
    @Column(name = "isolation",columnDefinition = "int COMMENT '数据隔离' ")
    private int isolation;

    @Column(name = "version" , columnDefinition = "int COMMENT '版本' ")
    private int version;

    @Column(name = "versionSecond", columnDefinition = "int COMMENT '小版本'")
    private Integer versionSecond;




    @Column(name = "isMax" , columnDefinition = "int COMMENT '是否为最高版本' ")
    private int isMax;

    @Column(name = "userId" , columnDefinition = "VARCHAR(50) COMMENT '申请人id' ")
    private String userId;

    @Column(name = "isJia" , columnDefinition = "VARCHAR(50) COMMENT '是否甲供料' ")
    private String isJia;

    @Column(name = "userName" , columnDefinition = "VARCHAR(50) COMMENT '申请人' ")
    private String userName;


}
